Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_RULES

`ALL_RULES` describes the rules accessible to the current user.

Related Views

- `DBA_RULES` describes all rules in the database.

- `USER_RULES` describes the rules owned by the current user. This view does not display the `RULE_OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`RULE_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the rule
`RULE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the rule
`RULE_CONDITION` | `CLOB` |  | Expressions and operators that constitute the rule condition
`RULE_EVALUATION_CONTEXT_OWNER` | `VARCHAR2(30)` |  | Owner of the evaluation context associated with the rule, if any
`RULE_EVALUATION_CONTEXT_NAME` | `VARCHAR2(30)` |  | Name of the evaluation context associated with the rule, if any
`RULE_ACTION_CONTEXT` | `RE$NV_LIST` |  | Action context associated with the rule, if any
`RULE_COMMENT` | `VARCHAR2(4000)` |  | Comment specified with the rule, if any

See Also: "DBA_RULES" "USER_RULES"